| Number of Variables | 23 |
|---|---|
| Number of Rows | 34508 |
| Missing Cells | 109086 |
| Missing Cells (%) | 13.7% |
| Duplicate Rows | 0 |
| Duplicate Rows (%) | 0.0% |
| Total Size in Memory | 23.5 MB |
| Average Row Size in Memory | 714.6 B |
| Variable Types |
|
| DonorUniqueId is uniformly distributed | Uniform |
|---|---|
| LastFiscalYearDonation and Donation2FiscalYearsAgo have similar distributions | Similar Distribution |
| LastFiscalYearDonation and Donation3FiscalYearsAgo have similar distributions | Similar Distribution |
| LastFiscalYearDonation and Donation4FiscalYearsAgo have similar distributions | Similar Distribution |
| LastFiscalYearDonation and Donation5FiscalYearsAgo have similar distributions | Similar Distribution |
| LastFiscalYearDonation and CurrentFiscalYearDonation have similar distributions | Similar Distribution |
| Donation2FiscalYearsAgo and Donation3FiscalYearsAgo have similar distributions | Similar Distribution |
| Donation2FiscalYearsAgo and Donation4FiscalYearsAgo have similar distributions | Similar Distribution |
| Donation2FiscalYearsAgo and Donation5FiscalYearsAgo have similar distributions | Similar Distribution |
| Donation2FiscalYearsAgo and CurrentFiscalYearDonation have similar distributions | Similar Distribution |
| Donation3FiscalYearsAgo and Donation4FiscalYearsAgo have similar distributions | Similar Distribution |
|---|---|
| Donation3FiscalYearsAgo and Donation5FiscalYearsAgo have similar distributions | Similar Distribution |
| Donation3FiscalYearsAgo and CurrentFiscalYearDonation have similar distributions | Similar Distribution |
| Donation4FiscalYearsAgo and Donation5FiscalYearsAgo have similar distributions | Similar Distribution |
| Donation4FiscalYearsAgo and CurrentFiscalYearDonation have similar distributions | Similar Distribution |
| Donation5FiscalYearsAgo and CurrentFiscalYearDonation have similar distributions | Similar Distribution |
| MaritalStatus has 24568 (71.2%) missing values | Missing |
| GenderIdentity has 493 (1.43%) missing values | Missing |
| WealthRating has 31799 (92.15%) missing values | Missing |
| AcademicDegreeLevel has 26902 (77.96%) missing values | Missing |
| PreferredAddressType has 4043 (11.72%) missing values | Missing |
|---|---|
| DonorDateOfBirth has 21190 (61.41%) missing values | Missing |
| DonorUniqueId is skewed | Skewed |
| DonorPostalCode is skewed | Skewed |
| DonorAge is skewed | Skewed |
| ConsecutiveDonorYears is skewed | Skewed |
| LastFiscalYearDonation is skewed | Skewed |
| Donation2FiscalYearsAgo is skewed | Skewed |
| Donation3FiscalYearsAgo is skewed | Skewed |
| Donation4FiscalYearsAgo is skewed | Skewed |
| Donation5FiscalYearsAgo is skewed | Skewed |
|---|---|
| CurrentFiscalYearDonation is skewed | Skewed |
| CumulativeDonationAmount is skewed | Skewed |
| DonorDateOfBirth has a high cardinality: 4812 distinct values | High Cardinality |
| IsMemberFlag has constant value "N" | Constant |
| IsMemberFlag has constant length 1 | Constant Length |
| IsAlumnusFlag has constant length 1 | Constant Length |
| IsParentFlag has constant length 1 | Constant Length |
| HasInvolvementFlag has constant length 1 | Constant Length |
| AcademicDegreeLevel has constant length 2 | Constant Length |
| HasEmailFlag has constant length 1 | Constant Length |
|---|---|
| DonorIndicatorFlag. has constant length 1 | Constant Length |
| ConsecutiveDonorYears has 18236 (52.85%) zeros | Zeros |
| LastFiscalYearDonation has 32139 (93.13%) zeros | Zeros |
| Donation2FiscalYearsAgo has 32032 (92.82%) zeros | Zeros |
| Donation3FiscalYearsAgo has 31971 (92.65%) zeros | Zeros |
| Donation4FiscalYearsAgo has 32362 (93.78%) zeros | Zeros |
| Donation5FiscalYearsAgo has 32544 (94.31%) zeros | Zeros |
| CurrentFiscalYearDonation has 32599 (94.47%) zeros | Zeros |
| CumulativeDonationAmount has 13075 (37.89%) zeros | Zeros |
numerical
| Approximate Distinct Count | 34508 |
|---|---|
| Approximate Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Memory Size | 552128 |
| Mean | 17254.5 |
| Minimum | 1 |
| Maximum | 34508 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negatives | 0 |
| Negatives (%) | 0.0% |
| Minimum | 1 |
|---|---|
| 5-th Percentile | 1726.35 |
| Q1 | 8627.75 |
| Median | 17254.5 |
| Q3 | 25881.25 |
| 95-th Percentile | 32782.65 |
| Maximum | 34508 |
| Range | 34507 |
| IQR | 17253.5 |
| Mean | 17254.5 |
|---|---|
| Standard Deviation | 9961.7459 |
| Variance | 9.9236e+07 |
| Sum | 5.9542e+08 |
| Skewness | 0 |
| Kurtosis | -1.2 |
| Coefficient of Variation | 0.5773 |
numerical
| Approximate Distinct Count | 20991 |
|---|---|
| Approximate Unique (%) | 61.0% |
| Missing | 91 |
| Missing (%) | 0.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Memory Size | 550672 |
| Mean | 56161.626 |
| Minimum | 211 |
| Maximum | 99928 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negatives | 0 |
| Negatives (%) | 0.0% |
| Minimum | 211 |
|---|---|
| 5-th Percentile | 6837.6 |
| Q1 | 29927 |
| Median | 58108 |
| Q3 | 90265 |
| 95-th Percentile | 94940.2 |
| Maximum | 99928 |
| Range | 99717 |
| IQR | 60338 |
| Mean | 56161.626 |
|---|---|
| Standard Deviation | 29966.7045 |
| Variance | 8.98e+08 |
| Sum | 1.9329e+09 |
| Skewness | -0.2166 |
| Kurtosis | -1.3063 |
| Coefficient of Variation | 0.5336 |
numerical
| Approximate Distinct Count | 102 |
|---|---|
| Approximate Unique (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Memory Size | 552128 |
| Mean | 43.367 |
| Minimum | 1 |
| Maximum | 110 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negatives | 0 |
| Negatives (%) | 0.0% |
| Minimum | 1 |
|---|---|
| 5-th Percentile | 26 |
| Q1 | 42 |
| Median | 42 |
| Q3 | 42 |
| 95-th Percentile | 66 |
| Maximum | 110 |
| Range | 109 |
| IQR | 0 |
| Mean | 43.367 |
|---|---|
| Standard Deviation | 11.4057 |
| Variance | 130.0905 |
| Sum | 1.4965e+06 |
| Skewness | 1.4386 |
| Kurtosis | 4.2964 |
| Coefficient of Variation | 0.263 |
categorical
| Approximate Distinct Count | 6 |
|---|---|
| Approximate Unique (%) | 0.1% |
| Missing | 24568 |
| Missing (%) | 71.2% |
| Memory Size | 712660 |
| Mean | 6.6962 |
|---|---|
| Standard Deviation | 0.4965 |
| Median | 7 |
| Minimum | 6 |
| Maximum | 13 |
| 1st row | Married |
|---|---|
| 2nd row | Married |
| 3rd row | Married |
| 4th row | Single |
| 5th row | Married |
| Count | 66557 |
|---|---|
| Lowercase Letter | 56614 |
| Space Separator | 3 |
| Uppercase Letter | 9943 |
| Dash Punctuation | 0 |
| Decimal Number | 0 |
categorical
| Approximate Distinct Count | 5 |
|---|---|
| Approximate Unique (%) | 0.0% |
| Missing | 493 |
| Missing (%) | 1.4% |
| Memory Size | 2382606 |
| Mean | 5.0457 |
|---|---|
| Standard Deviation | 0.9997 |
| Median | 6 |
| Minimum | 1 |
| Maximum | 7 |
| 1st row | Female |
|---|---|
| 2nd row | Female |
| 3rd row | Female |
| 4th row | Female |
| 5th row | Female |
| Count | 171631 |
|---|---|
| Lowercase Letter | 137616 |
| Space Separator | 0 |
| Uppercase Letter | 34015 |
| Dash Punctuation | 0 |
| Decimal Number | 0 |
categorical
| Approximate Distinct Count | 1 |
|---|---|
| Approximate Unique (%) | 0.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory Size | 2277528 |
| Mean | 1 |
|---|---|
| Standard Deviation | 0 |
| Median | 1 |
| Minimum | 1 |
| Maximum | 1 |
| 1st row | N |
|---|---|
| 2nd row | N |
| 3rd row | N |
| 4th row | N |
| 5th row | N |
| Count | 34508 |
|---|---|
| Lowercase Letter | 0 |
| Space Separator | 0 |
| Uppercase Letter | 34508 |
| Dash Punctuation | 0 |
| Decimal Number | 0 |
categorical
| Approximate Distinct Count | 2 |
|---|---|
| Approximate Unique (%) | 0.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory Size | 2277528 |
| Mean | 1 |
|---|---|
| Standard Deviation | 0 |
| Median | 1 |
| Minimum | 1 |
| Maximum | 1 |
| 1st row | N |
|---|---|
| 2nd row | Y |
| 3rd row | N |
| 4th row | Y |
| 5th row | N |
| Count | 34508 |
|---|---|
| Lowercase Letter | 0 |
| Space Separator | 0 |
| Uppercase Letter | 34508 |
| Dash Punctuation | 0 |
| Decimal Number | 0 |
categorical
| Approximate Distinct Count | 2 |
|---|---|
| Approximate Unique (%) | 0.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory Size | 2277528 |
| Mean | 1 |
|---|---|
| Standard Deviation | 0 |
| Median | 1 |
| Minimum | 1 |
| Maximum | 1 |
| 1st row | N |
|---|---|
| 2nd row | N |
| 3rd row | N |
| 4th row | N |
| 5th row | N |
| Count | 34508 |
|---|---|
| Lowercase Letter | 0 |
| Space Separator | 0 |
| Uppercase Letter | 34508 |
| Dash Punctuation | 0 |
| Decimal Number | 0 |
categorical
| Approximate Distinct Count | 2 |
|---|---|
| Approximate Unique (%) | 0.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory Size | 2277528 |
| Mean | 1 |
|---|---|
| Standard Deviation | 0 |
| Median | 1 |
| Minimum | 1 |
| Maximum | 1 |
| 1st row | N |
|---|---|
| 2nd row | Y |
| 3rd row | N |
| 4th row | Y |
| 5th row | N |
| Count | 34508 |
|---|---|
| Lowercase Letter | 0 |
| Space Separator | 0 |
| Uppercase Letter | 34508 |
| Dash Punctuation | 0 |
| Decimal Number | 0 |
categorical
| Approximate Distinct Count | 8 |
|---|---|
| Approximate Unique (%) | 0.3% |
| Missing | 31799 |
| Missing (%) | 92.2% |
| Memory Size | 215912 |
| Mean | 14.7017 |
|---|---|
| Standard Deviation | 2.7146 |
| Median | 15 |
| Minimum | 10 |
| Maximum | 21 |
| 1st row | $50,000-$99,999 |
|---|---|
| 2nd row | $50,000-$99,999 |
| 3rd row | $50,000-$99,999 |
| 4th row | $50,000-$99,999 |
| 5th row | $100,000-$249,999 |
| Count | 0 |
|---|---|
| Lowercase Letter | 0 |
| Space Separator | 0 |
| Uppercase Letter | 0 |
| Dash Punctuation | 2709 |
| Decimal Number | 26736 |
categorical
| Approximate Distinct Count | 7 |
|---|---|
| Approximate Unique (%) | 0.1% |
| Missing | 26902 |
| Missing (%) | 78.0% |
| Memory Size | 509602 |
| Mean | 2 |
|---|---|
| Standard Deviation | 0 |
| Median | 2 |
| Minimum | 2 |
| Maximum | 2 |
| 1st row | UB |
|---|---|
| 2nd row | GP |
| 3rd row | UB |
| 4th row | GP |
| 5th row | GM |
| Count | 15212 |
|---|---|
| Lowercase Letter | 0 |
| Space Separator | 0 |
| Uppercase Letter | 15212 |
| Dash Punctuation | 0 |
| Decimal Number | 0 |
categorical
| Approximate Distinct Count | 4 |
|---|---|
| Approximate Unique (%) | 0.0% |
| Missing | 4043 |
| Missing (%) | 11.7% |
| Memory Size | 2102014 |
| Mean | 3.9977 |
|---|---|
| Standard Deviation | 0.04822 |
| Median | 4 |
| Minimum | 3 |
| Maximum | 4 |
| 1st row | HOME |
|---|---|
| 2nd row | HOME |
| 3rd row | HOME |
| 4th row | HOME |
| 5th row | HOME |
| Count | 121789 |
|---|---|
| Lowercase Letter | 0 |
| Space Separator | 0 |
| Uppercase Letter | 121789 |
| Dash Punctuation | 0 |
| Decimal Number | 0 |
categorical
| Approximate Distinct Count | 2 |
|---|---|
| Approximate Unique (%) | 0.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory Size | 2277528 |
| Mean | 1 |
|---|---|
| Standard Deviation | 0 |
| Median | 1 |
| Minimum | 1 |
| Maximum | 1 |
| 1st row | N |
|---|---|
| 2nd row | Y |
| 3rd row | N |
| 4th row | Y |
| 5th row | Y |
| Count | 34508 |
|---|---|
| Lowercase Letter | 0 |
| Space Separator | 0 |
| Uppercase Letter | 34508 |
| Dash Punctuation | 0 |
| Decimal Number | 0 |
numerical
| Approximate Distinct Count | 33 |
|---|---|
| Approximate Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Memory Size | 552128 |
| Mean | 1.1375 |
| Minimum | 0 |
| Maximum | 36 |
| Zeros | 18236 |
| Zeros (%) | 52.8% |
| Negatives | 0 |
| Negatives (%) | 0.0% |
| Minimum | 0 |
|---|---|
| 5-th Percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 1 |
| 95-th Percentile | 5 |
| Maximum | 36 |
| Range | 36 |
| IQR | 1 |
| Mean | 1.1375 |
|---|---|
| Standard Deviation | 2.423 |
| Variance | 5.8711 |
| Sum | 39252 |
| Skewness | 5.1025 |
| Kurtosis | 37.921 |
| Coefficient of Variation | 2.1302 |
numerical
| Approximate Distinct Count | 188 |
|---|---|
| Approximate Unique (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Memory Size | 552128 |
| Mean | 377.6168 |
| Minimum | 0 |
| Maximum | 10000000 |
| Zeros | 32139 |
| Zeros (%) | 93.1% |
| Negatives | 0 |
| Negatives (%) | 0.0% |
| Minimum | 0 |
|---|---|
| 5-th Percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th Percentile | 1 |
| Maximum | 10000000 |
| Range | 10000000 |
| IQR | 0 |
| Mean | 377.6168 |
|---|---|
| Standard Deviation | 54048.3693 |
| Variance | 2.9212e+09 |
| Sum | 1.3031e+07 |
| Skewness | 183.5974 |
| Kurtosis | 33953.0792 |
| Coefficient of Variation | 143.1302 |
numerical
| Approximate Distinct Count | 189 |
|---|---|
| Approximate Unique (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Memory Size | 552128 |
| Mean | 96.2011 |
| Minimum | 0 |
| Maximum | 1932960 |
| Zeros | 32032 |
| Zeros (%) | 92.8% |
| Negatives | 0 |
| Negatives (%) | 0.0% |
| Minimum | 0 |
|---|---|
| 5-th Percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th Percentile | 25 |
| Maximum | 1932960 |
| Range | 1932960 |
| IQR | 0 |
| Mean | 96.2011 |
|---|---|
| Standard Deviation | 10454.7132 |
| Variance | 1.093e+08 |
| Sum | 3.3197e+06 |
| Skewness | 183.1952 |
| Kurtosis | 33855.5723 |
| Coefficient of Variation | 108.6757 |
numerical
| Approximate Distinct Count | 188 |
|---|---|
| Approximate Unique (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Memory Size | 552128 |
| Mean | 63.7549 |
| Minimum | 0 |
| Maximum | 500000 |
| Zeros | 31971 |
| Zeros (%) | 92.7% |
| Negatives | 0 |
| Negatives (%) | 0.0% |
| Minimum | 0 |
|---|---|
| 5-th Percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th Percentile | 25 |
| Maximum | 500000 |
| Range | 500000 |
| IQR | 0 |
| Mean | 63.7549 |
|---|---|
| Standard Deviation | 3282.1957 |
| Variance | 1.0773e+07 |
| Sum | 2.2001e+06 |
| Skewness | 118.0373 |
| Kurtosis | 16458.0103 |
| Coefficient of Variation | 51.4814 |
numerical
| Approximate Distinct Count | 177 |
|---|---|
| Approximate Unique (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Memory Size | 552128 |
| Mean | 57.1188 |
| Minimum | 0 |
| Maximum | 250000 |
| Zeros | 32362 |
| Zeros (%) | 93.8% |
| Negatives | 0 |
| Negatives (%) | 0.0% |
| Minimum | 0 |
|---|---|
| 5-th Percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th Percentile | 1 |
| Maximum | 250000 |
| Range | 250000 |
| IQR | 0 |
| Mean | 57.1188 |
|---|---|
| Standard Deviation | 2594.5566 |
| Variance | 6.7317e+06 |
| Sum | 1.9711e+06 |
| Skewness | 76.4564 |
| Kurtosis | 6508.8006 |
| Coefficient of Variation | 45.4239 |
numerical
| Approximate Distinct Count | 182 |
|---|---|
| Approximate Unique (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Memory Size | 552128 |
| Mean | 126.6312 |
| Minimum | 0 |
| Maximum | 1250000 |
| Zeros | 32544 |
| Zeros (%) | 94.3% |
| Negatives | 0 |
| Negatives (%) | 0.0% |
| Minimum | 0 |
|---|---|
| 5-th Percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th Percentile | 11 |
| Maximum | 1250000 |
| Range | 1250000 |
| IQR | 0 |
| Mean | 126.6312 |
|---|---|
| Standard Deviation | 10064.3897 |
| Variance | 1.0129e+08 |
| Sum | 4.3698e+06 |
| Skewness | 114.455 |
| Kurtosis | 13899.8891 |
| Coefficient of Variation | 79.478 |
numerical
| Approximate Distinct Count | 166 |
|---|---|
| Approximate Unique (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Memory Size | 552128 |
| Mean | 197.7946 |
| Minimum | 0 |
| Maximum | 2000000 |
| Zeros | 32599 |
| Zeros (%) | 94.5% |
| Negatives | 0 |
| Negatives (%) | 0.0% |
| Minimum | 0 |
|---|---|
| 5-th Percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th Percentile | 1 |
| Maximum | 2000000 |
| Range | 2000000 |
| IQR | 0 |
| Mean | 197.7946 |
|---|---|
| Standard Deviation | 15850.5703 |
| Variance | 2.5124e+08 |
| Sum | 6.8255e+06 |
| Skewness | 118.6523 |
| Kurtosis | 14756.0427 |
| Coefficient of Variation | 80.1365 |
numerical
| Approximate Distinct Count | 1595 |
|---|---|
| Approximate Unique (%) | 4.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Memory Size | 552128 |
| Mean | 2363.5342 |
| Minimum | 0 |
| Maximum | 1.2222e+07 |
| Zeros | 13075 |
| Zeros (%) | 37.9% |
| Negatives | 0 |
| Negatives (%) | 0.0% |
| Minimum | 0 |
|---|---|
| 5-th Percentile | 0 |
| Q1 | 0 |
| Median | 25 |
| Q3 | 144 |
| 95-th Percentile | 1309 |
| Maximum | 1.2222e+07 |
| Range | 1.2222e+07 |
| IQR | 144 |
| Mean | 2363.5342 |
|---|---|
| Standard Deviation | 113801.4399 |
| Variance | 1.2951e+10 |
| Sum | 8.1561e+07 |
| Skewness | 94.4472 |
| Kurtosis | 9612.7056 |
| Coefficient of Variation | 48.1488 |
categorical
| Approximate Distinct Count | 4812 |
|---|---|
| Approximate Unique (%) | 36.1% |
| Missing | 21190 |
| Missing (%) | 61.4% |
| Memory Size | 984216 |
| Mean | 8.9012 |
|---|---|
| Standard Deviation | 0.5761 |
| Median | 9 |
| Minimum | 8 |
| Maximum | 10 |
| 1st row | 6/16/1985 |
|---|---|
| 2nd row | 12/3/1987 |
| 3rd row | 9/11/1950 |
| 4th row | 1/23/1961 |
| 5th row | 9/14/1978 |
| Count | 0 |
|---|---|
| Lowercase Letter | 0 |
| Space Separator | 0 |
| Uppercase Letter | 0 |
| Dash Punctuation | 0 |
| Decimal Number | 91910 |
categorical
| Approximate Distinct Count | 2 |
|---|---|
| Approximate Unique (%) | 0.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory Size | 2277528 |
| Mean | 1 |
|---|---|
| Standard Deviation | 0 |
| Median | 1 |
| Minimum | 1 |
| Maximum | 1 |
| 1st row | Y |
|---|---|
| 2nd row | Y |
| 3rd row | Y |
| 4th row | N |
| 5th row | Y |
| Count | 34508 |
|---|---|
| Lowercase Letter | 0 |
| Space Separator | 0 |
| Uppercase Letter | 34508 |
| Dash Punctuation | 0 |
| Decimal Number | 0 |